[dbo].[BAEEventGetFunctions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetFunctions

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(15)	15

SQL Script

CREATE procedure [dbo].[BAEEventGetFunctions] @eventCode varchar(15) as
SELECT *
    FROM Product p
    INNER JOIN Product_Function pf on pf.PRODUCT_CODE = p.PRODUCT_CODE
    WHERE p.PRODUCT_MAJOR = @eventCode AND LEN(p.PRODUCT_MINOR) > 1
    AND (pf.IS_GUEST_FUNCTION IS NULL OR pf.IS_GUEST_FUNCTION = 0)
    AND pf.WEB_ENABLED = '1';

GO

Uses

[dbo].[Product]
[dbo].[Product_Function]
dbo